<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@page import="com.jdbc.Jdbc"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="com.project.bean.*"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.List"%>
<%@page import="java.sql.*" %>

<%
	String classname = request.getParameter("classname");
	String centername = request.getParameter("centername");
	String checkdate = request.getParameter("checkdate");
	/* System.out.println(classname);
	System.out.println(centername);
	System.out.println(check_date); */
	//获得查询的表格名称
	String checktable = centername + classname + "check";
	//获得查询的日期列是否存在，从checkdate中找

	
	ResultSet rs;
	List<Stu_class> list = new ArrayList<>();

	
	//若该日期存在，则继续进行查询
	ResultSet rs1;
	String[] b = checkdate.split("-");// 并且将2018-01-13转换为2018年01月13号
	String c = b[0] + "年" + b[1] + "月" + b[2] + "日";
	String find1 = "select * from " + checktable + " where " + c + " = '0' ";
	System.out.println(find1);
	Jdbc j1 = new Jdbc();
	try {
		j1.Jdbc_Q2(find1);
		rs1 = j1.rs;
		while (rs1.next()) {
			Stu_class sc = new Stu_class();
			sc.setStuid(rs1.getString("stuid"));
			sc.setChinesename(rs1.getString("stuname"));
			sc.setCentername(rs1.getString("centername"));
			sc.setClassname(rs1.getString("classname"));
			list.add(sc);
		}
	} catch (ClassNotFoundException | SQLException e) {
		// TODO Auto-generated catch block
		request.getRequestDispatcher("shownotcheckdate.jsp").forward(request, response);
		
	}
	
	
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>

<head>
<meta charset="utf-8">
<title>班级签到表</title>
<meta name="renderer" content="webkit">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport"
	content="width=device-width, initial-scale=1, maximum-scale=1">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="format-detection" content="telephone=no">
<link rel="stylesheet" href="./css/x-admin.css" media="all">
</head>
<body>
	<div class="x-nav">
		<span class="layui-breadcrumb"> <a><cite>首页</cite></a> <a><cite>签到管理</cite></a>
		</span>
		<!--             <a class="layui-btn layui-btn-small" style="line-height:1.6em;margin-top:3px;float:right"  href="javascript:location.replace(location.href);" title="刷新"><i class="layui-icon" style="line-height:30px">ဂ</i></a>
 -->
	</div>
	<div class="x-body">
		<form class="layui-form x-center" action="" style="width: 500px">
			<div class="layui-form-pane" style="margin-top: 15px;">
				<div class="layui-form-item">
					<div class="layui-input-inline" style="width: 400px"></div>
					<div class="layui-input-inline" style="width: 80px"></div>
				</div>
			</div>
		</form>
		<!--  <xblock>
            当日课时<select  name="classtime" id="id"><option
							selected="1">1</option>
						<option value="1">1</option>
						<option value="1.5">1.5</option></select>
            </xblock>  -->
		<table class="layui-table">
			<thead>
				<tr>
					<th>学号</th>
					<th>中文姓名</th>
					<th>课时选择</th>
					<th>补考勤</th>

					<th>操作</th>



				</tr>
			</thead>
			<tbody>
				<%
					for (Stu_class sc : list) {
				%>
				<tr>
					<form action="checkafter" method="post">
						<td><%=sc.getStuid()%><input type="hidden" name="stuid"
							value=<%=sc.getStuid()%>>
						<!-- 将学生的学号增加到表单中，但是将其影藏起来 --> <input type="hidden" name="stuname"
							value=<%=sc.getChinesename()%>> <input type="hidden"
							name="centername" value=<%=sc.getCentername()%>> <input
							type="hidden" name="classname" value=<%=sc.getClassname()%>>
							<input type="hidden" name="checkdate" value=<%=checkdate%>>
						</td>
						<td><%=sc.getChinesename()%></td>

						<td><select class="layui-input" name="classtime"><option
									value="1">1</option>
								<option value="1.5">1.5</option>

						</select></td>
						<td><select class="layui-input" name="checkaftertime"><option
									value="1">出勤</option>

								<option value="0">未出勤</option>
						</select></td>

						<td><input type="submit" value="登记"></td>
					</form>

					<%-- <td class="td-manage">
                           <a title="编辑" href="javascript:;" onclick="user_management_edit('编辑','contract_delete.jsp?stuid=<%=stuid%>','4','','510')"
                            class="ml-5" style="text-decoration:none">
                                <i class="layui-icon">&#xe642;</i>
                            </a> 
                            <!-- <a style="text-decoration:none"  onclick="user_management_password('修改密码','user_management_password.jsp','10001','600','400')"
                            href="javascript:;" title="修改密码">
                                <i class="layui-icon">&#xe631;</i>
                            </a> -->
                            <a title="添加" href="javascript:;" onclick="user_management_delete('加入班级','contract_delete.jsp?stuid=<%=stuid%>','10001','600','400')"
                            style="text-decoration:none">
                                <i class="layui-icon">&#xe640;</i>
                            </a>
                        </td> --%>
				</tr>


			</tbody>
			<%
				}
			%>
		</table>

		<!-- <div id="page"></div> -->
	</div>
	<br />
	<br />
	<br />
	<script src="./lib/layui/layui.js" charset="utf-8"></script>
	<script src="./js/x-layui.js" charset="utf-8"></script>
	<script>
		layui.use([ 'laydate', 'element', 'laypage', 'layer' ], function() {
			$ = layui.jquery;//jquery
			laydate = layui.laydate;//日期插件
			lement = layui.element();//面包导航
			laypage = layui.laypage;//分页
			layer = layui.layer;//弹出层

			//以上模块根据需要引入

			laypage({
				cont : 'page',
				pages : 100,
				first : 1,
				last : 100,
				prev : '<em><</em>',
				next : '<em>></em>'
			});

			var start = {
				min : laydate.now(),
				max : '2099-06-16 23:59:59',
				istoday : false,
				choose : function(datas) {
					end.min = datas; //开始日选好后，重置结束日的最小日期
					end.start = datas //将结束日的初始值设定为开始日
				}
			};

			var end = {
				min : laydate.now(),
				max : '2099-06-16 23:59:59',
				istoday : false,
				choose : function(datas) {
					start.max = datas; //结束日选好后，重置开始日的最大日期
				}
			};

		});

		//批量删除提交
		function delAll() {
			layer.confirm('确认要删除吗？', function(index) {
				//捉到所有被选中的，发异步进行删除
				layer.msg('删除成功', {
					icon : 1
				});
			});
		}
		/*用户-添加*/
		function user_management_add(title, url, w, h) {
			x_admin_show(title, url, w, h);
		}
		/*用户-查看*/
		function user_management_show(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}

		/*用户-停用*/
		function member_stop(obj, id) {
			layer
					.confirm(
							'确认要停用吗？',
							function(index) {
								//发异步把用户状态进行更改
								$(obj)
										.parents("tr")
										.find(".td-manage")
										.prepend(
												'<a style="text-decoration:none" onClick="member_start(this,id)" href="javascript:;" title="启用"><i class="layui-icon">&#xe62f;</i></a>');
								$(obj)
										.parents("tr")
										.find(".td-status")
										.html(
												'<span class="layui-btn layui-btn-disabled layui-btn-mini">已停用</span>');
								$(obj).remove();
								layer.msg('已停用!', {
									icon : 5,
									time : 1000
								});
							});
		}

		/*用户-启用*/
		function member_start(obj, id) {
			layer
					.confirm(
							'确认要启用吗？',
							function(index) {
								//发异步把用户状态进行更改
								$(obj)
										.parents("tr")
										.find(".td-manage")
										.prepend(
												'<a style="text-decoration:none" onClick="member_stop(this,id)" href="javascript:;" title="停用"><i class="layui-icon">&#xe601;</i></a>');
								$(obj)
										.parents("tr")
										.find(".td-status")
										.html(
												'<span class="layui-btn layui-btn-normal layui-btn-mini">已启用</span>');
								$(obj).remove();
								layer.msg('已启用!', {
									icon : 6,
									time : 1000
								});
							});
		}
		// 用户-编辑
		function user_management_edit(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}
		/*密码-修改*/
		function user_management_password(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}
		//删除用户
		function user_management_delete(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}
		/*用户-删除*/
		function member_del(obj, id) {
			layer.confirm('确认要删除吗？', function(index) {
				//发异步删除数据
				$(obj).parents("tr").remove();
				layer.msg('已删除!', {
					icon : 1,
					time : 1000
				});
			});
		}
	</script>
	<script>
		var _hmt = _hmt || [];
		(function() {
			var hm = document.createElement("script");
			var s = document.getElementsByTagName("script")[0];
			s.parentNode.insertBefore(hm, s);
		})();
	</script>
</body>
</html>
